<?php
define('InEmpireBakData',TRUE);
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 5.1
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `jzb_checkup`;");
E_C("CREATE TABLE `jzb_checkup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL,
  `checkup_no` varchar(50) DEFAULT NULL COMMENT '鉴定单号',
  `uid` int(11) DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `description` mediumtext NOT NULL,
  `province_id` char(6) NOT NULL,
  `city_id` char(6) NOT NULL,
  `area_id` char(6) NOT NULL,
  `address` char(100) NOT NULL,
  `mobile` char(20) NOT NULL,
  `realname` char(20) NOT NULL,
  `create_time` int(11) NOT NULL,
  `modify_time` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL COMMENT '0待付款1待发出2聚真宝待收货3正在鉴定4待收货5已完成6已取消',
  `shipping_price` decimal(10,2) DEFAULT NULL COMMENT '运费',
  `total` decimal(10,2) DEFAULT NULL,
  `identify_price` decimal(10,2) DEFAULT NULL COMMENT '鉴定费用',
  `is_show` tinyint(4) DEFAULT '1' COMMENT '1显示 0删除 则不显示',
  `remark` text COMMENT '鉴定结果备注',
  `identify_time` int(11) DEFAULT NULL COMMENT '鉴定时间',
  `comment` varchar(255) DEFAULT NULL COMMENT '客户留言',
  `pay_time` int(11) DEFAULT NULL,
  `payment_log_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8");

require("../../inc/footer.php");
?>